{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":18,"n_cols":13,"rows_kept":18}
[]
[{"$nulls":5},"Unit Fund"]
["Premiums",1000]
["allocation",0.5,0.99,null,null,"year","premium","allocated","bid price","accumulate","return","AMC","post AMC"]
["BO spread",0.05,{"$nulls":3},1,{"$f":"$B$3","v":{"v":1000,"d":"1,000.00"}},{"$f":"G5*B4","v":{"v":500,"d":"500.00"}},{"$f":"H5*(1-$B$5)","v":{"v":475,"d":"475.00"}},{"$f":"I5","v":{"v":475,"d":"475.00"}},{"$f":"J5*(1+$B$7)","v":{"v":508.25000000000006,"d":"508.25"}},{"$f":"K5*$B$6","v":{"v":5.0825000000000005,"d":"5.08"}},{"$f":"K5-L5","v":{"v":503.1675000000001,"d":"503.17"}}]
["AMC",0.01,{"$nulls":3},{"$f":"F5+1","v":2},{"$f":"$B$3","v":{"v":1000,"d":"1,000.00"}},{"$f":"$B$3*$C$4","v":{"v":990,"d":"990.00"}},{"$f":"H6*(1-$B$5)","v":{"v":940.5,"d":"940.50"}},{"$f":"I6+M5","v":{"v":1443.6675,"d":"1,443.67"}},{"$f":"J6*(1+$B$7)","v":{"v":1544.7242250000002,"d":"1,544.72"}},{"$f":"K6*$B$6","v":{"v":15.447242250000002,"d":"15.45"}},{"$f":"K6-L6","v":{"v":1529.2769827500001,"d":"1,529.28"}}]
["Return units",0.07,{"$nulls":3},{"$f":"F6+1","v":3},{"v":1000,"d":"1,000.00"},{"$f":"$B$3*$C$4","v":{"v":990,"d":"990.00"}},{"v":940.5,"d":"940.50"},{"$f":"I7+M6","v":{"v":2469.77698275,"d":"2,469.78"}},{"v":2642.6613715425,"d":"2,642.66"},{"v":26.426613715425002,"d":"26.43"},{"v":2616.234757827075,"d":"2,616.23"}]
["Return sterling",0.02,{"$nulls":3},4,{"v":1000,"d":"1,000.00"},{"v":990,"d":"990.00"},{"v":940.5,"d":"940.50"},{"v":3556.734757827075,"d":"3,556.73"},{"v":3805.7061908749706,"d":"3,805.71"},{"v":38.05706190874971,"d":"38.06"},{"v":3767.649128966221,"d":"3,767.65"}]
["Initial expenses",150,{"$nulls":3},5,{"v":1000,"d":"1,000.00"},{"v":990,"d":"990.00"},{"v":940.5,"d":"940.50"},{"v":4708.149128966221,"d":"4,708.15"},{"v":5037.719567993857,"d":"5,037.72"},{"v":50.377195679938566,"d":"50.38"},{"v":4987.3423723139185,"d":"4,987.34"}]
["Renewal expenses",30]
["expense increases",0.05,{"$nulls":3},"Sterling Fund"]
["term",5]
["sum assured",5000,{"$nulls":3},"Year","fees","expenses","interest","AMC","death ben","Cashflow"]
["age",60,{"$nulls":3},1,{"$f":"G5-I5","v":{"v":525,"d":"525.00"}},{"$f":"B9","v":{"v":150,"d":"150.00"}},{"$f":"(G14-H14)*$B$8","v":{"v":7.5,"d":"7.50"}},{"$f":"L5","v":{"v":5.0825000000000005,"d":"5.08"}},{"$f":"MAX(0,$B$13-M5)*$B$15","v":{"v":44.96832499999999,"d":"44.97"}},{"$f":"G14-H14+I14+J14-K14","v":{"v":342.614175,"d":"342.61"}}]
["q_x",0.01,{"$nulls":3},{"$f":"F14+1","v":2},{"$f":"G6-I6","v":{"v":59.5,"d":"59.50"}},{"$f":"B10","v":{"v":30,"d":"30.00"}},{"$f":"(G15-H15)*$B$8","v":0.59},{"$f":"L6","v":{"v":15.447242250000002,"d":"15.45"}},{"$f":"MAX(0,$B$13-M6)*$B$15","v":{"v":34.7072301725,"d":"34.71"}},{"$f":"G15-H15+I15+J15-K15","v":{"v":10.830012077500008,"d":"10.83"}}]
[{"$nulls":5},{"$f":"F15+1","v":3},{"v":59.5,"d":"59.50"},{"$f":"H15*(1+$B$11)","v":{"v":31.5,"d":"31.50"}},0.56,{"$f":"L7","v":{"v":26.426613715425002,"d":"26.43"}},{"$f":"MAX(0,$B$13-M7)*$B$15","v":{"v":23.83765242172925,"d":"23.84"}},{"v":31.148961293695752,"d":"31.15"}]
[{"$nulls":5},4,{"v":59.5,"d":"59.50"},{"$f":"H16*(1+$B$11)","v":{"v":33.075,"d":"33.08"}},{"v":0.5285,"d":"0.53"},{"$f":"L8","v":{"v":38.05706190874971,"d":"38.06"}},{"$f":"MAX(0,$B$13-M8)*$B$15","v":{"v":12.323508710337792,"d":"12.32"}},{"v":52.68705319841192,"d":"52.69"}]
[{"$nulls":5},5,{"v":59.5,"d":"59.50"},{"v":34.728750000000005,"d":"34.73"},{"v":0.4954249999999999,"d":"0.50"},{"$f":"L9","v":{"v":50.377195679938566,"d":"50.38"}},{"$f":"MAX(0,$B$13-M9)*$B$15","v":{"v":0.12657627686081468,"d":"0.13"}},{"v":75.51729440307774,"d":"75.52"}]